﻿USE [Pharmacy]
GO
/****** Object:  Table [dbo].[Client]    Script Date: 06/12/2011 23:56:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Client]') AND type in (N'U'))
DROP TABLE [dbo].[Client]
GO
/****** Object:  Table [dbo].[Lot]    Script Date: 06/12/2011 23:57:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Lot]') AND type in (N'U'))
DROP TABLE [dbo].[Lot]
GO
/****** Object:  Table [dbo].[Person]    Script Date: 06/12/2011 23:57:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Person]') AND type in (N'U'))
DROP TABLE [dbo].[Person]
GO
/****** Object:  Table [dbo].[Premios]    Script Date: 06/12/2011 23:57:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Premios]') AND type in (N'U'))
DROP TABLE [dbo].[Premios]
GO
/****** Object:  Table [dbo].[Presentation]    Script Date: 06/12/2011 23:57:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Presentation]') AND type in (N'U'))
DROP TABLE [dbo].[Presentation]
GO
/****** Object:  Table [dbo].[Product]    Script Date: 06/12/2011 23:57:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Product]') AND type in (N'U'))
DROP TABLE [dbo].[Product]
GO
/****** Object:  Table [dbo].[ProductCatalogue]    Script Date: 06/12/2011 23:57:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductCatalogue]') AND type in (N'U'))
DROP TABLE [dbo].[ProductCatalogue]
GO
/****** Object:  Table [dbo].[Provider]    Script Date: 06/12/2011 23:57:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Provider]') AND type in (N'U'))
DROP TABLE [dbo].[Provider]
GO
/****** Object:  Table [dbo].[Purchase]    Script Date: 06/12/2011 23:57:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Purchase]') AND type in (N'U'))
DROP TABLE [dbo].[Purchase]
GO
/****** Object:  Table [dbo].[PurchaseDetail]    Script Date: 06/12/2011 23:57:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PurchaseDetail]') AND type in (N'U'))
DROP TABLE [dbo].[PurchaseDetail]
GO
/****** Object:  Table [dbo].[Rent]    Script Date: 06/12/2011 23:57:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Rent]') AND type in (N'U'))
DROP TABLE [dbo].[Rent]
GO
/****** Object:  Table [dbo].[RentDetail]    Script Date: 06/12/2011 23:57:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RentDetail]') AND type in (N'U'))
DROP TABLE [dbo].[RentDetail]
GO
/****** Object:  Table [dbo].[Sale]    Script Date: 06/12/2011 23:57:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Sale]') AND type in (N'U'))
DROP TABLE [dbo].[Sale]
GO
/****** Object:  Table [dbo].[SaleDetail]    Script Date: 06/12/2011 23:57:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SaleDetail]') AND type in (N'U'))
DROP TABLE [dbo].[SaleDetail]
GO
/****** Object:  Table [dbo].[Stock]    Script Date: 06/12/2011 23:57:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Stock]') AND type in (N'U'))
DROP TABLE [dbo].[Stock]
GO
/****** Object:  Table [dbo].[Stock]    Script Date: 06/12/2011 23:57:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Stock]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Stock](
	[CodeProduct] [varchar](100) NOT NULL,
	[Quantity] [float] NOT NULL,
	[PriceSale] [float] NOT NULL,
	[PricePurchase] [float] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SaleDetail]    Script Date: 06/12/2011 23:57:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SaleDetail]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SaleDetail](
	[CodeSale] [varchar](100) NOT NULL,
	[CodProduct] [varchar](100) NOT NULL,
	[UnitPrice] [float] NOT NULL,
	[Quantity] [float] NOT NULL,
	[TotalPrice] [float] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Sale]    Script Date: 06/12/2011 23:57:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Sale]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Sale](
	[Code] [varchar](100) NOT NULL,
	[CodeClient] [varchar](100) NOT NULL,
	[CodeUser] [varchar](100) NOT NULL,
	[DateSale] [datetime] NOT NULL,
	[TotalPriceSale] [float] NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[RentDetail]    Script Date: 06/12/2011 23:57:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RentDetail]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[RentDetail](
	[CodeRent] [varchar](100) NOT NULL,
	[Amount] [float] NOT NULL,
	[Note] [varchar](100) NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Rent]    Script Date: 06/12/2011 23:57:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Rent]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Rent](
	[CodeRent] [varchar](100) NOT NULL,
	[CodeUser] [varchar](100) NOT NULL,
	[CurrentDate] [datetime] NOT NULL,
	[Concept] [varchar](100) NOT NULL,
	[Category] [varchar](100) NOT NULL,
	[TotalAmount] [float] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PurchaseDetail]    Script Date: 06/12/2011 23:57:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PurchaseDetail]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[PurchaseDetail](
	[CodePurchase] [varchar](100) NOT NULL,
	[CodProduct] [varchar](100) NOT NULL,
	[UnitPrice] [float] NOT NULL,
	[Quantity] [float] NOT NULL,
	[TotalPrice] [float] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Purchase]    Script Date: 06/12/2011 23:57:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Purchase]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Purchase](
	[Code] [varchar](100) NOT NULL,
	[NitProvider] [varchar](100) NOT NULL,
	[CodeUser] [varchar](100) NOT NULL,
	[DatePurchase] [datetime] NOT NULL,
	[TotalPurchase] [float] NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Provider]    Script Date: 06/12/2011 23:57:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Provider]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Provider](
	[Nit] [varchar](100) NOT NULL,
	[Name] [varchar](100) NOT NULL,
	[Email] [varchar](100) NOT NULL,
	[Web] [varchar](100) NOT NULL,
	[Contact] [varchar](100) NULL,
	[Cellular] [varchar](100) NULL,
	[Telephone] [varchar](100) NULL,
	[Address] [varchar](100) NULL,
	[Active] [bit] NOT NULL,
	[DateRegister] [datetime] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ProductCatalogue]    Script Date: 06/12/2011 23:57:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductCatalogue]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ProductCatalogue](
	[CodeProduct] [varchar](50) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[Presentation] [varchar](50) NOT NULL,
	[Description] [varchar](100) NOT NULL,
	[Image] [varchar](20) NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Product]    Script Date: 06/12/2011 23:57:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Product]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Product](
	[Code] [varchar](20) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[PresentationCode] [varchar](50) NOT NULL,
	[Provider] [varchar](50) NOT NULL,
	[Admission] [datetime] NULL,
	[State] [varchar](5) NULL,
	[Description] [varchar](50) NULL,
	[RecetMedic] [varchar](5) NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Presentation]    Script Date: 06/12/2011 23:57:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Presentation]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Presentation](
	[Code] [varchar](5) NOT NULL,
	[Description] [varchar](50) NOT NULL,
	[State] [varchar](5) NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Premios]    Script Date: 06/12/2011 23:57:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Premios]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Premios](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Nombre] [varchar](50) NULL,
	[Precio] [float] NULL,
	[Habilitado] [bit] NULL,
	[FechaDeIngreso] [datetime] NULL,
 CONSTRAINT [PK_Premios] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Person]    Script Date: 06/12/2011 23:57:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Person]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Person](
	[Id] [varchar](100) NOT NULL,
	[Telephone] [varchar](100) NULL,
	[Password] [varchar](100) NOT NULL,
	[Name] [varchar](100) NOT NULL,
	[Surname_1] [varchar](100) NOT NULL,
	[Surname_2] [varchar](100) NOT NULL,
	[Address] [varchar](100) NULL,
	[Cellular] [varchar](100) NULL,
	[Ocupation] [varchar](100) NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Lot]    Script Date: 06/12/2011 23:57:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Lot]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Lot](
	[CodeLot] [varchar](100) NOT NULL,
	[PurchaseCode] [varchar](100) NOT NULL,
	[DateExpiration] [varchar](100) NOT NULL,
	[PricePurchase] [float] NOT NULL,
	[Quantity] [float] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Client]    Script Date: 06/12/2011 23:56:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Client]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Client](
	[Nit] [varchar](100) NOT NULL,
	[Name] [varchar](100) NOT NULL,
	[Surname_1] [varchar](100) NOT NULL,
	[Surname_2] [varchar](100) NOT NULL,
	[Telephone] [varchar](100) NULL,
	[Cellular] [varchar](100) NULL,
	[Email] [varchar](100) NULL,
	[Address] [varchar](100) NULL,
	[State] [varchar](10) NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO

Insert into Premios Values('PLANCHA',12.3,0,'14-Mar-11 10:21:31 PM');
Insert into Premios Values('PLANCHA2',12.3,1,'14-Mar-11 10:21:31 PM');
Insert into Person Values('1','','123','Javier','Pardo','Gomez','micasa','','Administracion');
Insert into Person Values('2','2135','123','Pepe','Camacho','Peredo','micasa','3453425','Administracion');
Insert into Person Values('3','','123','Juan','Rojas','Lopez','micasa','','Administracion');
Insert into Client Values('101010','Jose','Bernabeu','Alvez','4829283','72289436','jose@gmail.com','micasa','A');
Insert into Client Values('111','Jose','Bernabeu','Alvez','4829283','72289436','jose@gmail.com','micasa','A');
Insert into Product Values('med001','Paracetamol','01','1214568','14-Mar-11 10:21:31 PM','A','cabeza, espalda','si');
Insert into Presentation Values('01','Tableta','A');
Insert into Presentation Values('02','Capsula','A');
Insert into Presentation Values('03','Jarabe','A');
Insert into Presentation Values('04','Suero','A');
Insert into Presentation Values('05','Jeringa','A');
Insert into Presentation Values('06','Supositorio','A');
Insert into Provider Values('1214568','Laboratorios INTI','laboratorios@hotmail.com','www.inti.com.bo','Roberto','72270122','4020064','Av America',1,'14-Mar-11 10:21:31 PM');
Insert into Provider Values('6408254','Laboratorios COFAR','laboratorios@hotmail.com','www.cofar.com.bo','Mauricio','7225415','4020064','Av Aroma',1,'14-Mar-11 10:21:31 PM');
Insert into Provider Values('1215456','Laboratorios INTI','laboratorios@hotmail.com','www.inti.com.bo','Roberto','72270122','4020064','Av America',0,'14-Mar-11 10:21:31 PM');
Insert into Provider Values('6407825','Laboratorios COFAR','laboratorios@hotmail.com','www.cofar.com.bo','Mauricio','7225415','4020064','Av Aroma',0,'14-Mar-11 10:21:31 PM');
Insert into Product Values('med002','Resfrianex','01','1214568','14-Mar-11 10:21:31 PM','A','ojos, cabeza','no');
Insert into Stock Values('med002',8,5,3);
Insert into Sale Values('1000','101010','1','18-Mar-11 10:21:31 PM',10);
Insert into SaleDetail Values('1000','med002',5,2,10);
Insert into Product Values('med003','AntibioticoX','03','1214568','14-Mar-11 10:21:31 PM','A','resfrio, mareos','no');
Insert into Stock Values('med003',20,50,3);
Insert into Sale Values('1006','101010','1','18-Mar-11 10:21:31 PM',100);
Insert into SaleDetail Values('1000','med003',50,2,100);
Insert into Sale Values('1006','101010','1','18-Mar-11 10:21:31 PM',100);
Insert into SaleDetail Values('1000','med100',50,1,100);

Insert into Product Values('med004','Producto4','01','6408254','23-Mar-11 10:21:31 PM','A','resfrio, mareos','no');
Insert into Product Values('med005','Producto5','01','6408254','22-Mar-11 10:21:31 PM','A','resfrio, mareos','no');
Insert into Product Values('med006','Producto6','02','6408254','24-Mar-11 10:21:31 PM','A','resfrio, mareos','no');
Insert into Product Values('med100','Producto6','03','6408254','24-Mar-11 10:21:31 PM','A','resfrio, mareos','no');

Insert into Product Values('med007','Producto7','05','1214568','25-Mar-11 10:21:31 PM','A','resfrio, mareos','no');
Insert into Product Values('med008','Producto8','01','1214568','26-Mar-11 10:21:31 PM','A','resfrio, mareos','no');
Insert into Product Values('med009','Producto9','03','1214568','26-Mar-11 10:30:54 PM','A','resfrio, mareos','no');

Insert into Stock Values('med004',20,10,7);
Insert into Stock Values('med005',30,3,2);
Insert into Stock Values('med006',40,7,5);

Insert into Stock Values('med007',70,3,2);
Insert into Stock Values('med008',100,13,10);
Insert into Stock Values('med009',20,29,25);
Insert into Stock Values('med100',20,29,25);

Insert into Purchase Values('6000','6408254','2','10-May-11 10:30:54 PM',400);
Insert into PurchaseDetail Values('6000','med004',7,20,140);
Insert into PurchaseDetail Values('6000','med005',2,30,60);
Insert into PurchaseDetail Values('6000','med006',5,40,200);

Insert into Purchase Values('6001','1214568','3','12-May-11 10:30:54 PM',1640);
Insert into PurchaseDetail Values('6001','med007',2,70,140);
Insert into PurchaseDetail Values('6001','med008',10,100,1000);
Insert into PurchaseDetail Values('6001','med009',25,20,500);

Insert into Rent Values('3000','1','2-May-11 10:30:54 PM','Pago de agua del mes de mayo','Agua',100);
Insert into RentDetail Values('3000',100,'Factura mes mayo 2011');

Insert into ProductCatalogue Values('med001','tapsin tabletas','Tableta','comprimidos de 100 mg, dolor de cabeza','00001');
Insert into ProductCatalogue Values('med002','aspirina','Tableta','comprimidos de 50 mg, dolor de cabeza','00002');
Insert into ProductCatalogue Values('med003','ibuprofeno','Tableta','comprimidos de 100 mg, desinflamatorio','00003');
Insert into ProductCatalogue Values('med004','desenfriol','Tableta','comprimidos de 100 mg, antigripal','00004');
Insert into ProductCatalogue Values('med005','hipoglusin','Tableta','comprimidos de 100 mg, diabetes','00005');
Insert into ProductCatalogue Values('med006','paracetamol','Tableta','comprimidos de 100 mg, dolor de cabeza','00006');
Insert into ProductCatalogue Values('med007','migra dioxadol','Tableta','comprimidos de 100 mg, migranias','00007');
Insert into ProductCatalogue Values('med008','diclofenaco','Tableta','comprimidos de 50 mg, antiflamatorio','00008');
Insert into ProductCatalogue Values('med009','bactrim forte','Tableta','comprimidos de 80 mg, antibiotico','00009');
Insert into ProductCatalogue Values('med010','flogene','Tableta','comprimidos de 100 mg, dolor de cabeza','00010');


Insert into ProductCatalogue Values('med011','pinosan','Jarabe','jarabe de 50 ml, jarabe para la tos','00011');
Insert into ProductCatalogue Values('med012','flutox','Jarabe','jarabe de 50 ml, jarabe para la tos','00012');
Insert into ProductCatalogue Values('med013','tarifol','Jarabe','jarabe de 50 ml, jarabe para la tos ninos','00013');
Insert into ProductCatalogue Values('med014','abrilar','Jarabe','jarabe de 50 ml, jarabe para la tos ninos','00014');
Insert into ProductCatalogue Values('med015','dextrometorfano','Jarabe','jarabe de 50 ml, jarabe para la tos','00015');
Insert into ProductCatalogue Values('med016','ambroxol','Jarabe','jarabe de 50 ml, jarabe para la tos ninos','00016');
Insert into ProductCatalogue Values('med017','diakof','Jarabe','jarabe de 50 ml, jarabe para la tos','00017');
Insert into ProductCatalogue Values('med018','eucamiel','Jarabe','jarabe de 50 ml, jarabe para el refrio','00018');
Insert into ProductCatalogue Values('med019','atosyl','Jarabe','jarabe de 50 ml, jarabe para la tos','00019');
Insert into ProductCatalogue Values('med020','parlatos','Jarabe','jarabe de 50 ml, jarabe para la tos','00020');


Insert into ProductCatalogue Values('med021','keleden','Capsula','capsula de 50 mg, para el extress','00021');
Insert into ProductCatalogue Values('med022','canesten','Capsula','capsula de 50 mg, para mujeres','00022');
Insert into ProductCatalogue Values('med023','calcefor','Capsula','capsula de 50 mg, para proporcionar calcio','00023');
Insert into ProductCatalogue Values('med024','tapsin capsulas','Capsula','capsula de 50 mg, antigripal','00024');
Insert into ProductCatalogue Values('med025','omeprazol','Capsula','capsula de 50 mg, para la gastritis','00025');
Insert into ProductCatalogue Values('med026','energisil','Capsula','capsula de 50 mg, para energia','00026');
Insert into ProductCatalogue Values('med027','dalay','Capsula','capsula de 50 mg, para el extress','00027');
Insert into ProductCatalogue Values('med028','ipogras','Capsula','capsula de 50 mg, para adelgazar','00028');
Insert into ProductCatalogue Values('med029','betavit','Capsula','capsula de 50 mg, energizante','00029');
Insert into ProductCatalogue Values('med030','xl-3','Capsula','capsula de 50 mg, antigripal','00030');

Insert into ProductCatalogue Values('med031','fisiologico','Suero','suero 0,9','00031');
Insert into ProductCatalogue Values('med032','dextrona','Suero','suero 0,5','00032');
Insert into ProductCatalogue Values('med033','glucosalino','Suero','suero 0,9','00033');
Insert into ProductCatalogue Values('med034','lactato riger','Suero','suero 0,5','00034');
Insert into ProductCatalogue Values('med035','manitol','Suero','suero 0,9','00035');
Insert into ProductCatalogue Values('med036','metrodinazol','Suero','suero 0,6','00036');


Insert into ProductCatalogue Values('med037','jeringa','Jeringa','jeringa insulina','00037');
Insert into ProductCatalogue Values('med038','carpule','Jeringa','jeringa dentista','00038');
Insert into ProductCatalogue Values('med039','jeringa','Jeringa','jeringa normal de 5 cc','00039');
Insert into ProductCatalogue Values('med040','jeringa','Jeringa','jeringa normal de 20 cc','00040');
Insert into ProductCatalogue Values('med041','jeringa','Jeringa','jeringa de cristal','00041');





